Commercial vs Mathematical Rounding of Numbers

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: Commercial vs Mathematical Rounding of Numbers

Feedback Type: Problem

Product Area: Notes Client

Technical Area: Functionality

Platform: Windows

Release: 8.5.3

Reproducible: Always

I have a finance app which appears to be rounding numbers mathematically, rather then commercially.

For example, 9.285, when displayed with only 2 decimal places is being shown as 9.28, instead of 9.29. This is the way the API is natively behaving and it doesn't seem right to me.

I found a technote which explains a similar phenomena in formula and LotusScript.
http://www-01.ibm.com/support/docview.wss?uid=swg21210270

It appears I can force commercial rounding, per field, using a nested @Round function as follows...

@Round(@Round(9.285; .00001); .01)

The result is then displayed as 9.29.

I do not want to have to do this for all fields in the database.

Is anyone aware of a global setting to force the notes API to use commercial rounding by default?

I can't think of any real-life scenario where mathematical rounding (rounding to the nearest EVEN number) would be appropriate. Therefore, I don't see why Lotus have adopted this approach.

Thanks

Feedback number WEBB972FER created by ~Vera Xanlu on 04/23/2013

Status: Open
Comments: